SUPPORT / SAMPLES & SAS NOTES
Problem Note 42689: 'EJB Exception: : com.sas.solutions.odcs.client.ReferentialConstraintException: one or more referential integrity constraints preclude deletion'
 |  |  |  |
If you are importing new, or deleting existing, exchange rate sets in SAS
ERROR removeExchangeRateGroupMapping() - u:dearmb - Error removing Exchange Rate Group 317 com.sas.solutions.odcs.client.ODCSRuntimeException: javax.transaction.TransactionRolledbackException: EJB Exception: : com.sas.solutions.odcs.client.ReferentialConstraintException: one or more referential integrity constraints preclude deletion: com.sas.solutions.odcs.client.model.VCubeID{321}This error occurs when an existing exchange rate set is marked for deletion. For example, importing a new exchange rate set 'A' would require that the existing exchange rate set be deleted.
As a workaround, associate a different exchange rate set to your model. Once you do that, you should be able to proceed with loading your exchange rate set; the existing rate set should be able to be deleted and the new one loaded. You should also be able to directly delete an existing exchange rate set once you associate a different exchange rate set to your model.
This is marked as fixed and should function properly in release 5.2 of SAS Financial Management.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 5.1 | 5.2 | 9.2 TS2M0 | 9.2 TS2M3 | ||